package com.og.ouroa.mapper;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.og.ouroa.pojo.entity.Course;
import com.og.ouroa.pojo.entity.CourseStudent;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.og.ouroa.pojo.entity.UserInfo;
import com.og.ouroa.pojo.vo.GradeTopVO;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author Us
 * @since 2021-12-13
 */
public interface CourseStudentMapper extends BaseMapper<CourseStudent> {

    void insertOne(Integer sid,Integer cid);

    IPage<Course> getBySid (Page<Course> page,Integer sid);

    IPage<UserInfo> getByCid (Page<UserInfo> page, Integer cid);

    IPage<GradeTopVO> greadTopByCid(Page<GradeTopVO> page, Integer cid,Integer type,Double grade);



}
